leetcode-sql/medium/570. Managers with at Least 5 Direct Reports.sql at main · cM2908/leetcode-sql · GitHub

Name: leetcode-sql/medium/570. Managers with at Least 5 Direct Reports.sql at main · cM2908/leetcode-sql · GitHub
Rating: 4.7 (7805 reviews)
1
2
3
4
5
6
7
8
9
10
WITH managers AS(
SELECT manager_id
FROM employee_570
GROUP BY manager_id
HAVINGCOUNT(manager_id)>=5
)

SELECT name
FROM employee_570
WHERE id IN (SELECT*FROM managers);